Exporting Grid View Filter Results
Hi OneStream Community, I had a question regarding extracting dimension metadata and properties from OneStream. Currently, when we go to the Dimension Library, apply member filters in the grid view, and then right-click and export to CSV, we can download file containing the metadata along with its properties. I’m trying to find out if there is a way to automate this instead of doing it manually. Ideally, I would like to extract the same information (based on member filters or a specific hierarchy) through something like a Dashboard, Data Management step, or Business Rule, so the export can be automated. Has anyone implemented something similar or know of an approach to achieve this?
Tabbed Dashboard
Hi, I have Dashboard with tabbed embedded reports. for example, MainDashboard - Tab1, Tab2, Tab3. Everything works fine when the user clicks on Tab of their choice for the fiscal year 2026. For Historical data I would like to show the same report for with changed tab. for example, MainDashboard - Tab1, Tab2, Tab4 for the he fiscal year 2025. If the user changes the Scenario from 2026 to 2025 or vice versa the dashboard report tab3/tab4 shows/hide based on FY. How can I achieve at the workflow level? Any help will be appreciated. Thanks.
How to read csv file from Documents/users folder?
Hi, I have been trying to read a csv file that is in Documents/Users/userxxxx folder. Not able to make it work. Getting an error. Below is the code Dim FileName As String = args.NameValuePairs.XFGetValue("Param1", String.Empty) Dim sourceFolder As String = $"Documents/Users/{StringHelper.RemoveSystemCharacters(si.UserName,False,False)}" Dim fullPath = sourceFolder & "/" & "abc.csv" Below is the error Could not find file 'P:\Program Files\OneStream Software\OneStreamAppRoot\OneStreamApp\Documents\Users\userxxxx\abc.csv'. Any idea why this is not working? Thank you, Mikki
Format - Header Text alignment
Hello, I would like to align vertically and horizontally the text on my column header (in Cube Views and Reports). It seems there is no option to do that in the format parameters (only in Excel). I have tried to use an inline Formula, at least for the Report format, but it is not working. I keep having errors messages. Do you know a solution to get a more consistent presentation ? Thank you in advance, Morgane
Automated User Provisioning: Best approach to sync Users & Security Groups?
Hi everyone, We need to automate user creation and security group assignments in OneStream using data from an external Identity system. I have two main questions: Is it feasible to fully automate this without manual intervention? What is the best way to implement it simply (avoiding heavy middleware)? We are considering two solutions: Just-in-Time (JIT) via OIS, and SCIM. Does anyone know how we can set these up? What is the recommended "standard" approach for this? Thanks for your help! Madiha
